■ In some cases, you may get several errors after running the initial synchronization. These show up in your NRDS log. We recommend that you resolve these errors before setting up your regularly scheduled synchronization task. There are a few steps you can take:
□ Run the following SQL on your iMIS database after the initial import to prepare iMIS to access the records directly from NRDS, instead of using the Batch Refresh files:
INSERT INTO [dbo].[AsiNrdsQueue]
([ID], [Direction], [NrdsId], [RecordType], [QueuedDateTime])
SELECT DISTINCT '', 'Inbound', [NrdsId], [RecordType], GETDATE() FROM [dbo].[AsiNrdsLog] WHERE [Direction] = 'Inbound' AND [Status] = 'Failed' AND [NrdsId] != '' AND [RecordType] != ''
□ Then, run an Inbound synchronization from the command line:
Asi.NrdsSync.exe In Verbose
□ Once the Inbound process completes, check your log. You will have to address any remaining errors individually. These might include validation table errors, date format errors, or other problems. The details of the errors are noted in your log. After resolving the errors for a contact, use the NRDS Sync By ID iPart or the NRDS Sync Buttons iPart to update from NRDS for the member, office, or association.
□ If you get a parsing error, then use the NRDS Sync by ID iPart to try to import the record using the NRDS ID.
□ If you get an error indicating that a Prefix value is not valid, you may need to add the missing prefix to the iMIS PREFIX validation table. You can do that from Desktop > Customers > Set up tables > General lookup/validation.
■ If you get a database connection error when you try to run a synchronization, there may be a problem with your connection credentials. To investigate, open the Asi.NrdsSync XML configuration file. By default it is located in C:\Program Files\ASI\iMIS\Net\bin. Find the DataSource.iMIS.Connection section and verify that the following values are correct for your iMIS database: Data Source (your server), Initial Catalog (your database), User ID and Password (the database credentials).
■ If you get an error for a particular record after it is synchronized with NRDS, or if you notice that changes which you made in iMIS are not being successfully saved to NRDS, check the following in the record’s data:
□ Ensure that you are the Point of Entry or have the proper authority to make changes to the record in NRDS.
□ Ensure the record has a status of Active; changes to Inactive records are not synchronized to NRDS.
□ Ensure the data fields meet the NRDS requirements for format, length, and required fields.